WorksheetsMicrosoft Excel Unit 1
Total questions: 15
Worksheet time: 9mins
Which of the following in options in Backstage View contains the command to change the file type of a saved file?
Info
New
Cells
Export
Which of the following groups on the home tab contains the commands to insert, delete and format cell width and height?
Editing
Cells
Styles
Number
Which tab on the Ribbon contains the function library?
Home
Insert
Formulas
Page Layout
Microsoft Excel is a computer program used to
Takes Notes
Enter, move, and use data.
Enter, analyze, and present data
Charts and data
Spreadsheets are made up of
Rows and colomns
Calculations and rows
Columns and spreadsheets
None of the above
A workbook is
Compilation of Data
Where you can store files
Contains one or more worksheets.
All of the above
The ribbon is Not
Rows and columns
Organizational Unit
Commands
Contains tabs and group
The home tab includes all of the following except:
Cells
Styles
Sparklines
Paragraph
Helpful Keys for Deleting Data Includes:
Backspace Key
Delete Key
None
Both Delete and Backspace Key
Type in the extensions for Excel.
(a)
What is the formula for the sum of fixed costs?
=Sum(D2:H8)
+Sum(D2:H8)
(D2:D8)
=H3:H5
What is an example of a variable cost?
Utilities
Water
Rent
Dining Out
What is an example of a fixed cost?
Credit card
Hair cut
Entertainment
Rent
What symbol activates the formula in Excel?
shift +
=
-
+
What is another way to Sum?
Alt and =
+
Alt and -
