Workplace Docs Lesson 5

17 termsStudBud Administration

Test your knowledge on spreadsheet fundamentals, functions, and advantages of cloud-based applications

Flashcards17 cardsFPractice quizPHost liveL

Questions 17

Answers

1
What is a workbook in Excel?
A data chart
A file with multiple sheets
A formula collection
A single spreadsheet
2
How do you create a new spreadsheet in Excel?
Insert > New
Home > New
File > New
View > New
3
What is the main disadvantage of cloud-based applications?
No collaboration options
Requires internet access
Only works on mobile
Limited features
4
What does an absolute reference do?
Only applies to text
Changes when copied
Is not used in formulas
Remains constant when copied
5
What is the purpose of using a style guide in spreadsheets?
To ensure consistency
To limit creativity
To confuse users
To add more data
6
Which symbol indicates multiplication in formulas?
*
/
-
+
7
What is the primary purpose of spreadsheets?
To store images
To create presentations
To perform calculations
To write documents
8
What is the role of formatting in spreadsheets?
To limit functionality
To add more data
To confuse users
To make it look nice
9
What is the purpose of naming cells in Excel?
To make formulas easier
To confuse users
To hide data
To add colors
10
What is a function in Excel?
A pre-written formula
A type of chart
A data entry method
A formatting style
11
What is the first step to enter a formula?
Press Enter
Click the cell for the answer
Type the function name
Select the range of cells
12
What is the purpose of using headings in a spreadsheet?
To hide information
To identify data purpose
To add color
To confuse users
13
What does the AutoSum function do?
Counts cells
Finds maximum value
Adds specified cells
Finds average
14
What is a cell reference in a formula?
A formatting option
A type of function
A location in a spreadsheet
A fixed value
15
Which application is NOT a spreadsheet software?
Google Sheets
Microsoft Excel
Open Office
Adobe Photoshop
16
What is the significance of using formulas in spreadsheets?
To create charts
To automate calculations
To store data
To make data pretty
17
What is the advantage of cloud-based spreadsheets?
Only works on Windows
Requires no internet
Limited sharing options
Access from any device

Workplace Docs Lesson 5 Flashcards | StudBud

Workplace Docs Lesson 5

17 termsStudBud Administration

Test your knowledge on spreadsheet fundamentals, functions, and advantages of cloud-based applications

Flashcards17 cardsFPractice quizPHost liveL

Questions 17

Answers

1
What is a workbook in Excel?
A data chart
A file with multiple sheets
A formula collection
A single spreadsheet
2
How do you create a new spreadsheet in Excel?
Insert > New
Home > New
File > New
View > New
3
What is the main disadvantage of cloud-based applications?
No collaboration options
Requires internet access
Only works on mobile
Limited features
4
What does an absolute reference do?
Only applies to text
Changes when copied
Is not used in formulas
Remains constant when copied
5
What is the purpose of using a style guide in spreadsheets?
To ensure consistency
To limit creativity
To confuse users
To add more data
6
Which symbol indicates multiplication in formulas?
*
/
-
+
7
What is the primary purpose of spreadsheets?
To store images
To create presentations
To perform calculations
To write documents
8
What is the role of formatting in spreadsheets?
To limit functionality
To add more data
To confuse users
To make it look nice
9
What is the purpose of naming cells in Excel?
To make formulas easier
To confuse users
To hide data
To add colors
10
What is a function in Excel?
A pre-written formula
A type of chart
A data entry method
A formatting style
11
What is the first step to enter a formula?
Press Enter
Click the cell for the answer
Type the function name
Select the range of cells
12
What is the purpose of using headings in a spreadsheet?
To hide information
To identify data purpose
To add color
To confuse users
13
What does the AutoSum function do?
Counts cells
Finds maximum value
Adds specified cells
Finds average
14
What is a cell reference in a formula?
A formatting option
A type of function
A location in a spreadsheet
A fixed value
15
Which application is NOT a spreadsheet software?
Google Sheets
Microsoft Excel
Open Office
Adobe Photoshop
16
What is the significance of using formulas in spreadsheets?
To create charts
To automate calculations
To store data
To make data pretty
17
What is the advantage of cloud-based spreadsheets?
Only works on Windows
Requires no internet
Limited sharing options
Access from any device