» exceltest-orkla Learnesy Tests

Before you start the test, please read the following:

- The test consists of 10 questions, varying in degrees of difficulty
- Takes approx. 10 minutes to complete
- All questions are answered in the browser, you don't need to open Excel
- You will see your score after you have answered all the questions in the test

Namn

E-post

E-mail

An Excel file appears to have some columns missing, what is causing it?

The two missing columns have been moved to another worksheet

Some features in Excel requires reserved cell ranges, making the utilized columns temporary invisible for the user

The two columns are manually hidden

The two columns are passsword protected

What tool in Excel generates colors based on cell values?

Mini Charts

Data Charts

Conditional formatting

Quick Analysis

Which formula (written in cell B3) can be copied to all remaining cells in the multiplication table, making it correct?

=B2*A3

=\$B\$2*A3

=B\$2*\$A3

=\$B2*A\$3

What is a slicer in Excel?

A functionality to split your datasets

A way to quickly filter Tables and PivotTables

A way to remove incorrect data

A function to work with multiple sheets simultaniously

Which function can be used to return the quantity of products for a specific order ID?

VLOOKUP()

FIND()

MATCH()

REFERENCE()

What tool in Excel generates the following table?

DataTable

PivotTable

Quick Anaysis

Data Analysis

What will the following formula return?

Paris

London

Error

False

The three tables in the picture logs continuosly opening prices for exchange markets. Which one represents a correct tabular format?

Table 1

Table 2

Table 3

All tables are correct

In Excel, we can get data with functions only from sheets in the same workbook.

True

False

You open an Excel file and see dates displayed as numbers, what might be wrong?

The numbers need to be wrapped inside a DATE-function

To see the date, we need to divide the numbers by 365

Excel stores dates as numbers - we just need to reformat the cells as dates

The Excel file uses a deprecated character encoding

You stumble upon the following formula when opening an Excel file, what conclusion can you make?

The formula is generated by Power Pivot

The formula refers to columns in an Excel table and uses therefore structural references

The formula refers to named ranges i Excel

The formula syntax is faulty

Which changes should we do to the PivotTable seen at left, for it to become identical to the one on the right hand side?

We should view the PivotTable in tabular form and repeat the labels

We should drag "City" from rows to columns in the field list

We should summarize the value field by count

We have to separate "City" and "Country" to two separate columns with Power Query

What will happen if we copy the following formula all the way to cell D10?

The formula syntax is wrong resulting in an error

It would return the current row of the formula

It would sort the array in an descending order

It would sort the array in a ascending order

In Excel, there is an option for creating and managing queries. What is a query?

A query is when Excel sends a request for data through a connection we have established to a data source

A query is used to verify your identity when working with confidential data through the cloud

A query lets you actively validate formatting and table structures so that they meet company standards

A query automatically models relationships for all the tables that we have connected to