4. Excel Comprehension MCQ

Ctrl + _ is used to redo the last action (This is common is most programs, not just Excel)

• Y

• A

• C

• B

Which of the following stores the frequently used commands?

• Quick Access Toolbar

• Ribbon

• Status Bar

• Help

What is the primary objective of the Excel workbook?

• To store any type of data

• To save user time

• To make the calculations easier

• To analyse the data

What is the output of below calculation?

=23+8/(2*2)

• 25

• 24

• 24.5

• 22

What is the output of below calculation?...

=12/2+4^2

• 22

• 25

• 24.5

• 23

What is the shortcut key to select the entire worksheet in Excel?

• Ctrl+Shift+Space

• Alt+Shift+Space

• Shift+Space

• All of the above

Which of the following will not cut information from one location to another?

• Pressing Ctrl + C

• Selecting Edit > Cut from the menu

• Clicking the Cut button on the standard

• Pressing Ctrl+X

You can copy data or formulas:

• With the copy, paste and cut commands on the edit menu

• With commands on the shortcut menu

• With buttons on the standard toolbars

• All of the above

Each excel file is called a workbook because

• It can contain many sheets including worksheets and chart sheets

• It can contain text and data

• It can be modified

• You have to work hard to create it

The numbers in our worksheet look like this: 1000.

You want them to look like this: $1,000. How can you accomplish this?

• Click the Currency Style button on the formatting toolbar

• Select Format > Money from the menu

• You have to retype everything and manually add the dollar signs, commas, and decimals

• None of these