WorksheetsIntroduction to Excel Week 1
Total questions: 12
Worksheet time: 23mins
What function would you use to sum a range of cells in Excel?
A) SUM
B) AVERAGE
C) COUNT
D) MAX
What is the keyboard shortcut to save a workbook in Excel?
Ctrl + V
Ctrl + X
Ctrl + B
Ctrl + S
How can you insert a new row in an Excel spreadsheet?
Press Ctrl + R.
Right-click on the row number and select "Insert" from the context menu.
Press Ctrl + Shift + R.
Click on the "Insert" button in the Home tab of the ribbon.
How can you format a cell to display currency values?
Use the "Number Format" dropdown menu in the Home tab of the ribbon and select "Currency."
Type "$" symbol before the value in the cell.
Press Ctrl + Shift + $
Right-click on the cell, select "Format Cells," choose the "Currency" category, and then select the desired currency format.
What does the "AutoFill" feature in Excel do?
Automatically formats cells based on conditional formatting rules.
Automatically fills cells with random data.
Automatically completes a series or pattern of data based on a selection.
Automatically adjusts the width of the selected cells to fit the content.
How can you change the font size of selected text in Excel?
Right-click on the selected text, choose "Font," and then adjust the font size.
Press Ctrl + Shift + >.
Use the "Font Size" dropdown menu in the Home tab of the ribbon and select the desired font size.
Press Ctrl + Shift + F.
How can you adjust and decrease the width of a cell in Excel?
Select the column(s) containing the cell(s) you want to adjust.
Place your cursor on the right edge of the column header until it turns into a double-headed arrow.
Click and drag the column boundary to the left to decrease the width or to the right to increase it.
Release the mouse button when the column is at the desired width.
What functions are commonly used to perform calculations such as counting?
COUNT: counts the number of cells in a range that contains numbers.
COUNTA
CONCATINATE
COUNTIFS
What functions are commonly used to perform calculations such as finding the maximum value
MAXIF
MAXIMUM
MAX: This function returns the largest value in a range.
MAXIFAX
What functions are commonly used to perform calculations such as finding the minimum value,
MINIMUM
MINI
MINIF
MIN: This function returns the smallest value in a range.
What are the differences between the "Wrap Text" and "Merge Cells" features in Excel?
"Wrap Text" is a formatting feature that allows the contents of a cell to be displayed on multiple lines within the same cell,"Merge Cells" is a formatting feature that combines two or more adjacent cells into one larger cell, both horizontally and vertically.
Wrap Text automatically adjusts the row height to accommodate the wrapped text. merge cells is commonly used for creating headers, labels, or titles across multiple columns or rows.
This feature is useful when the content of a cell exceeds the width of the cell, allowing you to display the full content without resizing the column width.Merged cells lose their individual identities and become a single, larger cell with a single entry in the top-left corner.
To apply "Wrap Text," select the cell or range of cells, right-click, choose "Format Cells," go to the "Alignment" tab, and check the "Wrap text" box.To merge cells, select the cells you want to merge, right-click, choose "Merge & Center" from the context menu, and select the desired merge option.
How do you freeze panes in Excel?
Click on the "Page Layout" tab in the ribbon, then select "Freeze Panes" from the "Page Setup" group.
Press Ctrl + F to open the "Find and Replace" dialog, then select the "Freeze Panes" option from the dialog box.
Right-click on the row(s) or column(s) you want to freeze, then choose "Freeze Panes" from the context menu.
Select the row(s) or column(s) you want to freeze, then click on the "View" tab in the ribbon, and choose "Freeze Panes" from the dropdown menu.
