KSU IT 101 Activity Ch3

An illustration of a person working on a laptop with spreadsheets and charts on the screen, in a bright and modern office setting.

Mastering Excel: Test Your Skills!

Welcome to the KSU IT 101 Activity Ch3 quiz! This engaging quiz will challenge your understanding of Excel tools and functionalities. Whether you are a beginner or someone looking to refresh your knowledge, this quiz is designed for you.

Key features of the quiz:

  • 51 well-structured questions
  • Multiple choice format to test your knowledge
  • Instant feedback provided after each question
51 Questions13 MinutesCreated by LearningExcel101
The process of obtaining unstructured data from various sources, process and organize the data as required and finally visualize the required information is called _______.?
Ormula bar
Horizontal
Data analysis
Worksheet
An electronic spreadsheet or__________uses tabular structure to store and organize the data. It consists of rows and columns used for handling data.?
Ormula bar
Horizontal
Data analysis
Worksheet
The __________________________ displays the contents of the active cell and it is mainly used to enter a formula to calculate the cell data?
Ormula bar
Horizontal
Data analysis
Worksheet
The_____________________alignment determines the position of the data relative to the left and right margins of the cell.?
Ormula bar
Horizontal
Data analysis
Worksheet
The set of toolbars and commands placed under tabs.?
Active cell
Columns
Sheet tab
Ribbon
Worksheet
Single page of a workbook that consists of cells organized into rows and columns?
Active cell
Columns
Sheet tab
Ribbon
Worksheet
It is the currently selected cell; which is recognized by its green outline.?
Active cell
Columns
Sheet tab
Ribbon
Worksheet
The vertical divisions of a worksheet.?
Active cell
Columns
Sheet tab
Ribbon
Worksheet
It is at the bottom of the worksheet and displays the name of the sheets.?
Active cell
Columns
Sheet tab
Ribbon
Worksheet
Analyze the given worksheet and check the correct cell range that is selected.?
B1: C2
A1: H4
C8: F5
A4: E4
A1: G4
You cannot save a workbook at multiple locations.?
TRUE
FALSE
To edit the contents of a cell, single click on it and make the required changes.?
TRUE
FALSE
Use Shift+ Enter to move the active cell one row up in the worksheet?
TRUE
FALSE
The Bold command is used to rotate cell contents diagonally or vertically?
TRUE
FALSE
You can use Wrap text command to display long text into multiple lines?
TRUE
FALSE
This allows you to place an outline around the cells.?
Tab color
Remove duplicates
Workbook
Cell style
Cell border
Measure the cell data performance in terms of bad, good, neutral, warning etc?
Tab color
Remove duplicates
Workbook
Cell style
Cell border
It allows you to change the colors of worksheet tabs?
Tab color
Remove duplicates
Workbook
Cell style
Cell border
It examines selected data and removes duplicates within column values?
Tab color
Remove duplicates
Workbook
Cell style
Cell border
It contains only one worksheet by default but you can insert more worksheets.?
Tab color
Remove duplicates
Workbook
Cell style
Cell border
Excel assigns a default name to each worksheet in a workbook like A, B, C.?
TRUE
FALSE
Data manipulation is the proper handling of data that exist in excel worksheets.?
TRUE
FALSE
One feature that makes restructuring data simpler is Remove Duplicates?
TRUE
FALSE
Excel does not offer data cleaning tools?
TRUE
FALSE
Managing Worksheets is important to achieve a successful data analysis process.?
TRUE
FALSE
The data stored in worksheets is __________by default, which makes the data identification diffcult.?
General
Text sort
Currency
Filter
A column containing prices of different items is better displayed by applying a ________________symbol.?
General
Text sort
Currency
Filter
The ___________feature of Excel allows you to view specific data records in worksheets, while hiding the other data?
General
Text sort
Currency
Filter
The _________ allows you to arrange a list of names in an alphabetical order?
General
Text sort
Currency
Filter
Analysis is based on a specified condition such as Greater Than, Equal To etc.?
Variation Analysis
Rating Analysis
Table style
Data validation
Rule Analysis
Analysis is based on data variations in a specified range.?
Variation Analysis
Rating Analysis
Table style
Data validation
Rule Analysis
A set of icons (e.g. ratings) are used to represent the values in the cells.?
Variation Analysis
Rating Analysis
Table style
Data validation
Rule Analysis
Includes fonts, borders, and files coordinated to provide a professional appearance?
Variation Analysis
Rating Analysis
Table style
Data validation
Rule Analysis
You control the kind of information that is entered in your worksheet?
Variation Analysis
Rating Analysis
Table style
Data validation
Rule Analysis
Which conditional formatting is applied to the following data analysis sheet??
Color scales
Data bars
Icon sets
The data stored in worksheets is not general by default.?
TRUE
FALSE
Using conditional formatting, you can quickly identify variations in a data range?
TRUE
FALSE
With Data validation tool, you cannot check the accuracy and quality of data.?
TRUE
FALSE
Data protection is also essential to keep your workbook data safe and secure.?
TRUE
FALSE
Do not forget your password, else the file will be inaccessible.?
TRUE
FALSE
It outputs the number of characters in any given cell.?
AVERAGE()
COUNTIF()
SUMIF()
LEN()
COUNT()
It counts the number of cells that meet a criterion.?
AVERAGE()
COUNTIF()
SUMIF()
LEN()
COUNT()
It performs the statistical data analysis.?
AVERAGE()
COUNTIF()
SUMIF()
LEN()
COUNT()
It counts the number of cells in a range that contain numbers only?
AVERAGE()
COUNTIF()
SUMIF()
LEN()
COUNT()
It is used to add the values in a range that meets a specified criterion?
AVERAGE()
COUNTIF()
SUMIF()
LEN()
COUNT()
Choose the function to display Highest Amount for the given data?
SUMIF()
LEN()
AVERAGE()
MAX()
MIN()
You can also manually create formulas to calculate the numbers directly.?
TRUE
FALSE
Auto calculation feature manually calculates formulas & functions in real time?
TRUE
FALSE
Function is a preset or inbuilt formula that performs calculations automatically?
TRUE
FALSE
The SUM Function is a predefined formula that calculates the sum of values?
TRUE
FALSE
The MIN function is used to find the highest or maximum value?
TRUE
FALSE
{"name":"KSU IT 101 Activity Ch3", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Welcome to the KSU IT 101 Activity Ch3 quiz! This engaging quiz will challenge your understanding of Excel tools and functionalities. Whether you are a beginner or someone looking to refresh your knowledge, this quiz is designed for you.Key features of the quiz:51 well-structured questionsMultiple choice format to test your knowledgeInstant feedback provided after each question","img":"https:/images/course1.png"}
Powered by: Quiz Maker