NEW
Font size
WorksheetsMIDTERM EXAM OP1
Total questions: 50
Worksheet time: 50mins
What does the "Save As" option allow you to do in the File tab?
Save a copy of the workbook in a different location or format.
Close the workbook without saving.
Export the workbook as a PDF.
Print the workbook.
Which of the following formats is NOT available in the "Save As" dialog box?
.xlsx
.csv
.exe
What is the shortcut key to open the File tab in Excel?
Ctrl + P
Alt + F
Ctrl + S
Ctrl + O
Which command in the File tab would you use to create a new blank workbook?
Open
Save
New
Close
What does the "Print" option in the File tab allow you to do?
Save the workbook to OneDrive.
Adjust print settings and print the workbook.
Email the workbook to a colleague.
Convert the workbook to PDF.
Which of the following is available in the Info section of the File tab?
Recent documents
Workbook properties and protection options
Document templates
Workbook statistics
Which option in the File tab allows you to share a workbook with others?
Save As
Export
Share
Close
What does the "Close" option in the File tab do?
Exits Excel.
Saves the current workbook.
Closes the current workbook without exiting Excel.
Creates a new workbook.
In which section of the File tab can you protect a workbook with a password?
Save As
Info
Export
Which of the following can be found in the "Recent" section under the File tab?
Recent templates
Recently opened workbooks
Workbook history
System settings
What does the "Bold" button do in the Home tab?
Italicizes the selected text.
Makes the selected text bold.
Underlines the selected text.
Changes the font color.
Where can you find the "Merge & Center" button in Excel?
File tab
Home tab
Insert tab
Page Layout tab
Which button in the Home tab allows you to add borders to a selected cell or range?
Font Color
Fill Color
Borders
Conditional Formatting
Which command in the Home tab allows you to automatically sum a column or row of numbers?
Sort & Filter
Find & Select
AutoSum
Format Cells
In the Home tab, which group contains the "Cut," "Copy," and "Paste" commands?
Styles
Clipboard
Editing
Cells
The "Fill Color" option in the Home tab is used to:
Change the color of the font.
Apply a background color to a cell.
Insert a shape.
Highlight text.
What does the "Format as Table" option in the Home tab do?
Converts selected cells into a formatted table.
Changes the font style of the table.
Adjusts the row height and column width.
Adds borders to the table.
In the Home tab, what does the "Conditional Formatting" feature do?
Allows you to manually format a cell.
Applies formatting to cells based on specific criteria.
Sorts data alphabetically.
Adjusts the cell alignment.
Which of the following is NOT part of the Home tab?
Font Group
Alignment Group
Page Setup Group
Number Group
What does the "Increase Decimal" option in the Home tab do?
Adds a decimal point to a number.
Increases the number of decimal places displayed in a cell.
Rounds up the number in a cell.
Multiplies the number by 10.
Which of the following can be inserted using the Insert tab?
Data Validation
Charts
AutoSum
Filters
Which command in the Insert tab is used to add a table to a worksheet?
PivotTable
Table
Chart
Shapes
What does the "PivotTable" option in the Insert tab allow you to do?
Insert a bar chart.
Create a summary report based on selected data.
Filter data.
Format cells as currency.
Which button in the Insert tab allows you to add images to a worksheet?
Table
Pictures
Chart
Hyperlink
The "Header & Footer" option is found under which tab?
Home
Insert
File
View
In the Insert tab, which feature allows you to insert ready-made diagrams or visual representations of data?
SmartArt
Shapes
Text Box
PivotTable
Which of the following can you insert from the Text group in the Insert tab?
Header & Footer
Data Validation
Filter
Format as Table
In the Insert tab, what does the "Chart" option allow you to do?
Create tables from selected data.
Insert graphical representations of your data, such as bar or line charts.
Perform data sorting.
Filter your data.
Which of the following is a feature available in the Insert tab that allows you to link to external data or websites?
Filter
Hyperlink
Data Validation
AutoSum
Which option in the Insert tab allows you to add a line or arrow to your worksheet?
Chart
SmartArt
Shapes
Text Box
What does the "Orientation" option in the Page Layout tab allow you to change?
Font alignment
Page margins
Page size
Page layout to portrait or landscape
Which of the following is a function of the Page Layout tab?
Adjusting font color
Changing the page size
Sorting data
Inserting tables
Where would you go to add a watermark in Excel?
Home tab
Insert tab
Page Layout tab
Data tab
Which of the following can be adjusted in the "Margins" option under the Page Layout tab?
Font size
Page number
The space between the content and the edge of the paper
Header and footer text
What is the function of the "Print Titles" feature in the Page Layout tab?
Repeating column or row titles across multiple printed pages.
Changing the page orientation.
Inserting a title for the workbook.
Adjusting the font size of the headers.
What does the "Page Break" option in the Page Layout tab do?
Inserts a new worksheet.
Changes the orientation of the page.
Inserts a page break to control where the new page starts in print layout.
Changes the font of the headers.
Which of the following can be changed in the "Scale to Fit" group in the Page Layout tab?
Font size
Sheet zoom level
Width and height of printed content
Worksheet gridlines
In the Page Layout tab, where can you find the option to change the paper size?
Page Setup
Themes
Sheet Options
Margins
Which feature in the Page Layout tab allows you to select a theme for the worksheet?
Print Titles
Background
Themes
Scale to Fit
What does the "Background" option in the Page Layout tab allow you to do?
Change the background color of a worksheet.
Insert a picture as a worksheet background.
Add shading to cells.
Apply a new worksheet theme.
What does the "View Gridlines" option in the Page Layout tab do?
Displays gridlines in the printed worksheet.
Adds gridlines to the cells.
Enables or disables the view of gridlines on the worksheet.
Resizes the gridlines.
Which option in the Page Layout tab allows you to adjust the size of the worksheet for printing purposes?
Print Titles
Scale to Fit
Orientation
Margins
In the Page Layout tab, what does the "Sheet Options" group allow you to do?
Print gridlines and headings.
Insert new worksheets.
Change the color of the sheet tabs.
Merge and center text.
What does the "Page Setup" dialog box in the Page Layout tab allow you to do?
Adjust the zoom of the worksheet.
Configure print settings such as orientation, size, and margins.
Insert headers and footers.
Sort data alphabetically.
What does the "Themes" option in the Page Layout tab do?
Changes the color scheme, font, and effects applied to the worksheet.
Adjusts the page margins.
Adds filters to the worksheet.
Changes the data alignment.
Which Formula is written correctly for multiplying cell A1 and A7?
=A1+A7
=A1*A7
A1+A7
A1*A7
16. In Excel columns are labeled by letters.
True
False
20. If I want to add up a range of cells A1 through A25, which formula would I use?
=Sum(A1:A25)
(A1+A25)
=Sum(A1+A25)
+(A1+A25)
9. How can you use Excel to help in your everyday life?
Address List
Create a budget
Create a schedule
Create a grade book
All of the above
7. What does the button in the red rectangle do?
It adds a new workbook to the sheet
It adds a new sheet to the workbook
It adds a new sheet to the blanket
It adds a new sheet to the sheet
