Data Analytics Quiz

What is Microsoft Excel?

• Excel is a range of cells to be affected by rows and columns

• Excel is a spreadsheet application capable of organizing raw data into a readable format and manipulating it by performing calculations.

• Excel is a dropdown list with multiple data manipulation

• Excel is a cell address within a formula that does not include a $ symbol before the row number or column letter.

What are Cells?

• Cells are row letter and column numbers

• Cells are visible rows and columns

• Cells are Crosspoint of rows and column with a spreadsheet

• Cells are boxes that searches for a value in the first and second column

What is a cell reference?

• Cell reference combines both relative and absolute references

• The identification of cell location in the spreadsheet

• The combination of two variable cells

• The total arrangement of range of cell with multiple data

Cell referencing when dealing with formula is known as _____________________

• Absolute Reference

• Relative Reference

• Exact match Reference

• Mixed Reference

The following are Excel operators except ___________________

• ()

• 0

• %

• +-

An excel function that adds up cells that meets a specific criteria is known as ___________

• SUM()

• SUMIF()

• SUMIFS()

• SUM(A1+A2)

In MS Excel ________________ features makes it easier to add repetitive data to a worksheet

• Autosum

• Sort

• Filter

• Autocomplete

Formulas in Excel Starts with _____________________

• -

• =

• /

• ^

The process of adjusting the font type, color, cell border, and background color is known as ________________

• Data Filtering

• Data Arrangement

• Data formatting

• Data Sorting

MS Excel function used for searching for a specific value in one column and retrieving a corresponding value from another column in the same row is known as ___________

• HLOOKUP

• XLOOKUP

• VLOOKUP

• ZLOOKUP