NEW
Font size
WorksheetsMIDTERM EXAM IN OP1
Total questions: 50
Worksheet time: 25mins
Which option in the File tab allows you to save a workbook with a new name?
Open
Save
Save As
Which of the following actions can be performed using the File tab?
Print the worksheet
Insert a table
Format cells
Merge cells
The File tab allows you to:
Insert shapes
Create a chart
Save a workbook
Perform a spelling check
Which option in the File tab is used to export the workbook as a PDF?
Share
Export
Open
Under which option in the File tab can you check for compatibility with earlier versions of Excel?
Info
Save As
Open
Options
To protect a workbook with a password, you can find this option under:
Home
File -> Info
Insert
View
Which option in the File tab allows you to access recent documents?
New
Info
Recent
Options
Which of the following can be found under the Info option in the File tab?
Protect Workbook
View Macros
Format Cells
Insert Table
To print a worksheet, which of the following options would you use from the File tab?
Open
Export
Save As
The Options command in the File tab allows you to:
Insert a new chart
Change Excel's default settings
Create a new workbook
Apply conditional formatting
In the Home tab, the option to apply bold formatting to text is found under:
Font group
Alignment group
Styles group
Cells group
The Format Cells dialog box is accessed from which group in the Home tab?
Font
Styles
Cells
Editing
In the Home tab, which command is used to change the number format (e.g., General, Currency)?
Font Size
Merge & Center
Number Format
Cell Styles
Which of the following commands is located in the Home tab's Alignment group?
Wrap Text
Insert Table
Conditional Formatting
Find & Select
The Home tab allows you to add or remove borders through which group?
Editing
Styles
Alignment
Font
The Fill Color option is located in which group on the Home tab?
Font
Cells
Styles
Alignment
The Merge & Center option is found in which group in the Home tab?
Font
Alignment
Editing
Styles
In the Home tab, what does the Wrap Text command do?
Adds text borders
Moves text to a new line within a cell
Combines multiple cells
Deletes the text from the cell
The Conditional Formatting option in the Home tab is used for:
Applying borders to cells
Adding headers and footers
Highlighting cells based on rules
Changing text alignment
Where is the Cut, Copy, and Paste command found in the Home tab?
Editing group
Font group
Clipboard group
Cells group
Which group in the Home tab contains the Insert Rows and Columns command?
Styles
Cells
Editing
Alignment
The Home tab's Editing group contains which of the following commands?
Sort & Filter
Find & Select
Fill
All of the above
In the Home tab, which option allows you to format numbers with a comma separator?
Wrap Text
Merge Cells
Comma Style
Conditional Formatting
The Home tab's Styles group includes:
Format Painter
Font Color
Cell Styles
Fill Color
The Home tab contains which feature to help adjust cell width automatically?
Conditional Formatting
AutoFit
Freeze Panes
Format Painter
To delete cells or rows, you would use which group in the Home tab?
Alignment
Editing
Cells
Font
AutoSum is located in which group of the Home tab?
Alignment
Editing
Font
Styles
Which group in the Home tab allows you to add cell borders?
Alignment
Font
Editing
Styles
The Home tab's Number group is used to:
Merge cells
Apply number formats such as Currency, Date, or Percentage
Insert charts
Format tables
Which command in the Home tab helps in clearing contents or formatting?
Delete
Clear
Format Painter
Filter
In the Insert tab, which command allows you to insert a table into a worksheet?
Shapes
Table
PivotTable
SmartArt
Which of the following objects can you add using the Insert tab?
PivotTable
Chart
Shapes
All of the above
The Insert tab provides an option to add a Chart in which group?
Charts
Tables
Links
Illustrations
The Insert tab's Links group allows you to:
Add a hyperlink
Insert shapes
Format cells
Adjust number formatting
Where can you find the PivotTable command in the Insert tab?
Tables group
Illustrations group
Links group
Text group
The Insert tab allows you to add headers and footers using which group?
Text
Tables
Illustrations
Charts
Which group in the Insert tab contains the Pictures command?
Charts
Links
Illustrations
Text
In the Insert tab, which command helps in adding a hyperlink to a worksheet?
PivotTable
Header & Footer
Hyperlink
SmartArt
The Insert tab allows you to add WordArt from which group?
Charts
Text
Illustrations
Tables
To insert a Shape, which group would you use in the Insert tab?
Tables
Illustrations
Charts
Text
Which of the following features is NOT found in the Insert tab?
Conditional Formatting
SmartArt
PivotTable
Pictures
Which group in the Insert tab allows you to create a Sparklines graph?
Illustrations
Tables
Charts
Sparklines
In the Insert tab, you can add a Slicer for filtering data from which group?
Tables
Links
Illustrations
Charts
To insert a Text Box into your Excel worksheet, which group in the Insert tab would you use?
Illustrations
Text
Charts
Links
The Insert tab includes a command to add SmartArt in which group?
Illustrations
Charts
Text
Tables
Which of the following can be inserted using the Insert tab?
PivotTable
Picture
Chart
All of the above
The Insert tab provides the option to create a new worksheet using which command?
Table
PivotTable
New Sheet
None of the above
In the Insert tab, which option allows you to add an online picture?
Picture
Online Pictures
Clip Art
Hyperlink
The Insert tab's Illustrations group includes the following commands EXCEPT:
Shapes
Chart
Picture
SmartArt
To add a Chart to your worksheet, which group should you use in the Insert tab?
Tables
Links
Charts
Illustrations
