NEW
Font size
WorksheetsExcel Basics Semester Exam
Total questions: 29
Worksheet time: 14mins
What is a workbook in Excel?
A single spreadsheet within a workbook
A file that contains one or more related worksheets
A document that stores and manipulates data in columns and rows
A frozen row or column that remains visible on the screen
What does the term "worksheet" refer to in Excel?
A file that contains one or more related worksheets
A single spreadsheet within a workbook
A document that stores and manipulates data in columns and rows
A tool for monitoring changes or growth in data over time
What is the default file extension for Excel workbooks?
CSV
XLSX
TXT
DOCX
What does the "Freeze Panes" feature do in Excel?
Hides rows or columns from view
Keeps a row or column visible on the screen regardless of scrolling
Applies formatting from copied cells to destination cells
Switches rows and columns of copied cells
What is the purpose of the "Hide/Unhide" feature in Excel?
To delete rows or columns permanently
To hide rows or columns from view without deleting them
To apply formatting to copied cells
To switch rows and columns of copied cells
What does "Paste Formatting" do in Excel?
Copies only the values of the copied cells
Applies the formatting from copied cells to destination cells
Switches rows and columns of copied cells
Hides rows or columns from view
What does the "Navigate" feature allow you to do in Excel?
Move through different parts of a workbook or worksheet
Import data from another source
Arrange data systematically within a workbook
Perform mathematical operations on numbers
What is the purpose of the "Import" feature in Excel?
To move through different parts of a workbook
To bring data into Excel from another source
To arrange data systematically within a workbook
To perform mathematical operations on numbers
What is the function of "Calculate" in Excel?
To monitor changes or growth in data
To perform mathematical operations on numbers within a spreadsheet
To arrange data systematically within a workbook
To bring data into Excel from another source
What are arithmetic operations in Excel?
Operations like addition, subtraction, multiplication, and division
Monitoring changes or growth in data
Arranging data systematically within a workbook
Importing data from another source
What does "AutoFit" do in Excel?
Automatically adjusts the width and height of a column, row, or cell
Automatically performs a calculation on a group of cells
Draws an outline around a cell or group of cells
Combines selected cells into one large cell
What is the function of "AutoSum" in Excel?
Automatically adjusts the width and height of a column
Automatically performs a calculation (like addition) on a group of cells
Draws an outline around a cell or group of cells
Combines selected cells into one large cell
What does "Cell Borders" do in Excel?
Draws an outline around a cell or group of cells
Automatically adjusts the width and height of a column
Combines selected cells into one large cell
Displays numerical information like date or percentage
What are "Cell Styles" in Excel?
Predefined formatting options for cells or groups of cells
The color of the cell background
A set of calculations applied to values in a spreadsheet
A computational procedure that performs a specific operation
What does "Fill Color" refer to in Excel?
The color of the cell background
Predefined formatting options for cells
A set of calculations applied to values in a spreadsheet
A computational procedure that performs a specific operation
What is a "Formula" in Excel?
A set of calculations applied to values in a spreadsheet
Predefined formatting options for cells
The color of the cell background
A computational procedure that performs a specific operation
What is the "Formula Bar" used for in Excel?
To display the contents of the active cell
To apply predefined formatting options
To draw an outline around a cell
To automatically adjust the width and height of a column
What is a "Function" in Excel?
A computational procedure that performs a specific operation
A set of calculations applied to values in a spreadsheet
Predefined formatting options for cells
The color of the cell background
What are "Function Arguments" in Excel?
The values inside the parentheses of a function
A computational procedure that performs a specific operation
A set of calculations applied to values in a spreadsheet
Predefined formatting options for cells
What does "Merge and Center" do in Excel?
Combines selected cells into one large cell and centers the content
Automatically adjusts the width and height of a column
Draws an outline around a cell or group of cells
Displays numerical information like date or percentage
What is "Number Formatting" used for in Excel?
Displays numerical information like date, monetary value, or percentage
Combines selected cells into one large cell
Automatically adjusts the width and height of a column
Draws an outline around a cell or group of cells
What does "Print Area" designate in Excel?
A section of a worksheet to be printed
Rows or columns repeated on each printed page
Text that begins a new line when reaching the end of a cell
Combines selected cells into one large cell
What are "Print Titles" in Excel?
Rows or columns repeated on each printed page
A section of a worksheet to be printed
Text that begins a new line when reaching the end of a cell
Combines selected cells into one large cell
What does "Wrap Text" do in Excel?
Begins a new line when text reaches the end of a cell
Combines selected cells into one large cell
Displays numerical information like date or percentage
Draws an outline around a cell or group of cells
What is the purpose of "Paste Values" in Excel?
Copies only the values of the copied cells without formatting
Applies formatting from copied cells to destination cells
Switches rows and columns of copied cells
Hides rows or columns from view
What is the purpose of "Navigate" in Excel?
To move through different parts of a workbook or worksheet
To import data from another source
To arrange data systematically within a workbook
To perform mathematical operations on numbers
What button will add up a group of numbers?
Equals button
Auto sum button
Plus symbol button
