100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
DIT Semester 2 Exam Questions and Answers $13.49   Add to cart
Quickly navigate to
Preview
  2.  
  3. Prep Tests
  4.  
  5. Prep Tests

Exam (elaborations)

DIT Semester 2 Exam Questions and Answers
 0 view  0 purchase
  • Course
  • Prep Tests
  • Institution
  • Prep Tests

DIT Semester 2 Exam Questions and Answers Excel provides the tools to create which type of documents? - ANSWER-workbooks What is the procedure to launch Excel from the Windows desktop? - ANSWER-Click the start button and then choose Microsoft Excel, Right click on the desk top and new , Microsof...

[Show more]

Preview 4 out of 47  pages

Document information

  • November 4, 2024
  • 47
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • dit semester 2 exam questions and answers

Written for

  • Prep Tests
  • Prep Tests

Seller

avatar-seller
KaylinHoffman

Content preview

Copyright © KAYLIN 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH NOVEMBER, 2024




DIT Semester 2 Exam Questions and Answers


Excel provides the tools to create which type of documents? - ANSWER✔✔-workbooks


What is the procedure to launch Excel from the Windows desktop? - ANSWER✔✔-Click the start button

and then choose Microsoft Excel, Right click on the desk top and new , Microsoft Excel, and then double

click it & Click the icon on the Windows task bar


Use the __________ option for quick access to the Excel application from the Windows desktop. -

ANSWER✔✔-pin


Which toolbar is located in the upper left corner of the Excel window? - ANSWER✔✔-Quick Access


The tools to edit the workbook are located on the __________. - ANSWER✔✔-ribbon


When you add ribbon commands to the Quick Access Toolbar, right-click the command and choose

__________. - ANSWER✔✔-Add to Quick Access Toolbar


The Quick Access Toolbar can be moved __________. - ANSWER✔✔-above the ribbon and below the

ribbon


Which key is used to display keyboard shortcuts (Keytips) on the ribbon? - ANSWER✔✔-Alt


The commands on each ribbon tab are organized into logical command __________. - ANSWER✔✔-

Groups


If you cannot find the command you need while working in the ribbon, where can you click to find more

options? - ANSWER✔✔-the Options arrow in the bottom right corner of the group



Copyright ©Stuvia International BV 2010-2024 Page 1/47

,Copyright © KAYLIN 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH NOVEMBER, 2024


Which view shows the options to open, save, print, and manage your Excel file? - ANSWER✔✔-Backstage


How many worksheets are included in a new blank workbook? - ANSWER✔✔-1


A/An __________ is the name of a box in a worksheet at the intersection of a row and column in which

information is typed. - ANSWER✔✔-cell


A/An __________, where you can type information, is outlined by a bold rectangle in your worksheet. -

ANSWER✔✔-Active Cell


A __________ displays descriptive text when you rest the pointer on a command or control in Excel. -

ANSWER✔✔-ScreenTip


In the Workbook Views group, click __________ to display the active worksheet without rulers, headers,

footers, or page breaks. - ANSWER✔✔-Normal


A __________ is an Excel file made up of one or more worksheets. - ANSWER✔✔-Workbook


Use the __________ on the bottom right side of the Quick Access Toolbar to add additional commands. -

ANSWER✔✔-drop-down arrow


To increase workspace you can __________ so that only the tabs display at the top of the screen. -

ANSWER✔✔-collapse the ribbon


In order to see additional customization options, select __________ from the Quick Access Toolbar drop-

down list to display the Excel Options dialog box. - ANSWER✔✔-More Commands


The __________ command enables you to view large worksheets in two panes or four quadrants. -

ANSWER✔✔-Split




Copyright ©Stuvia International BV 2010-2024 Page 2/47

,Copyright © KAYLIN 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH NOVEMBER, 2024


The __________ command on the View tab in the Workbook Views group opens windows side by side to

compare sections of a large worksheet. - ANSWER✔✔-Arrange All


The Close command on the File tab closes __________. - ANSWER✔✔-the entire workbook


The __________ tab contains the Backstage Open command. - ANSWER✔✔-File


What starts at the top of each worksheet, goes to the bottom, and is identified by a letter? -

ANSWER✔✔-Column


What starts at the left edge of each worksheet, extends to the right, and is identified by a number? -

ANSWER✔✔-row


Which tab on the ribbon do you select to view Backstage options? - ANSWER✔✔-File


Which command in Backstage displays details about the current file? - ANSWER✔✔-Info


Which tab holds commands for controlling the appearance of the active document? - ANSWER✔✔-View


What option on the View tab displays worksheet margins and page breaks and gives you an opportunity

to add a header or footer? - ANSWER✔✔-Page Layout


Where are the icons available to change views outside the ribbon? - ANSWER✔✔-status bar


What tab on the ribbon has the Split command, useful for viewing large worksheets? - ANSWER✔✔-

View


Which of the following commands is similar to Split? - ANSWER✔✔-New Window


Which of the following displays in the title bar when a new window is opened from the View tab? -

ANSWER✔✔-Book1:2



Copyright ©Stuvia International BV 2010-2024 Page 3/47

, Copyright © KAYLIN 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH NOVEMBER, 2024


The ribbon is organized into task-oriented __________. - ANSWER✔✔-Command Tabs


What is the maximum number of characters allowed in a file name? - ANSWER✔✔-255


To display the Open dialog box, which of the following should you press? - ANSWER✔✔-Ctrl + F12


By default, which of the following file types is displayed in the Excel Open dialog box? - ANSWER✔✔-

Excel


Which of the following should you press to close both an open file and Excel at the same time? -

ANSWER✔✔-Alt+F4


What is the purpose of the Name Box? - ANSWER✔✔-to indicate the current active cell(s)


On which tab will you find the Go To command? - ANSWER✔✔-Home


Which of the following is the Keyboard Shortcut, used to access help? - ANSWER✔✔-F1


Some Keyboards come equipped with a/an __________ key, which disables arrow key movement when

activated. - ANSWER✔✔-Scroll Lock


In order to display additional search options, which button in the Go To dialog box should you use? -

ANSWER✔✔-Special


An arrow in the bottom-right corner of a group on the ribbon tells you that which of the following is

available? - ANSWER✔✔-Dialog box


Which of the following is a selected cell? - ANSWER✔✔-Active Cell


Which feature enables you yo preview headers and footers, page breaks, and other features that will

print - ANSWER✔✔-Print Layout



Copyright ©Stuvia International BV 2010-2024 Page 4/47

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller KaylinHoffman. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $13.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

81989 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling

Recently viewed by you

Exam (elaborations) ·

(0)

Level 6 Aceable Correct 100%
$13.49
  • (0)
  Add to cart