WorksheetsUnit 7 Part 1 REVIEW: Introduction to Excel/Spreadsheets
Total questions: 17
Worksheet time: 9mins
A row in a spreadsheet can be described as:
Horizontal cells that are labeled by numbers
Horizontal cells that are labeled by letters
Vertical cells that are labeled by letters
Vertical cells that are labeled by numbers
What popular spreadsheet software runs primarily on Apple operating systems?
Microsoft Excel
Adobe Acrobat
Numbers
Google Sheets
What is NOT a part of a standard spreadsheet?
Formula Bar
Cells
Columns
Field Name
What types of mathematical formulas can spreadsheets perform?
Totals
Percentages
Averages
All of the above.
What is a formula bar?
The intersection of a row and column which is identified by a letter and number
Where data can be entered and edited, which then appears in the active cell
It displays the name or location of the active cell
Vertical cells that are labeled by letters.
Read the statements below and select T if the statement is true or F if the statement is false. Google Sheets is an expensive spreadsheet software used mainly by businesses.
True
False
Read the statements below and select T if the statement is true or F if the statement is false. Spreadsheets allow users to efficiently create business models, graphs, charts, and reports.
True
False
Read the statements below and select T if the statement is true or F if the statement is false. A spreadsheet is where data is entered, organized, and calculated.
True
False
Read the statements below and select T if the statement is true or F if the statement is false. All spreadsheet software is exactly the same and has the same features.
True
False
Read the statements below and select T if the statement is true or F if the statement is false. The most popular spreadsheet software programs are Microsoft Excel, Numbers, and Google Sheets.
True
False
Today, spreadsheet software is only used to complete accounting tasks.
True
False
List three reasons why students should learn spreadsheets.
Commonly used by businesses
Simplify many complicated tasks
Easily display information with graphs, charts, and infographics
Can use as a presentation
A spreadsheet is:
a type of document used to organize and analyze data in rows and columns.
a type of software used for graphic design.
a programming language used for web development.
a hardware device used for data storage.
You need to collaborate on a budget spreadsheet with a colleague. You live in New York, and your colleague lives in California. What is the best spreadsheet software to use and why?
Microsoft Excel because it is widely used and has robust features.
Google Sheets because it allows real-time collaboration and is accessible from anywhere.
Apple Numbers because it is user-friendly and integrates well with Apple devices.
LibreOffice Calc because it is free and open-source.
List four parts of a standard spreadsheet.
1. Name box 2. Formula bar 3. Column 4. Row
1. Title bar 2. Status bar 3. Page layout 4. Header
1. Toolbar 2. Footer 3. Page number 4. Margin
1. Chart 2. Legend 3. Axis 4. Data label
A worksheet is divided into a grid of _______.
height and width
rows and columns.
The set of data that runs left to right in a spreadsheet
column
row
cell
active cell
