Excel and Power BI Skills

What is a pivot table used for in Excel?

• Making cells look pretty like a fashion show

• Turning data into a pie chart that makes you hungry

• A pivot table is like a magician for summarizing and analyzing data!

• Sorting data like a librarian on caffeine

Which magical spell would you use to zap away those pesky extra spaces in Excel?

• DELETE

• CLEAN

• REMOVE

• TRIM

What does the TRIM function do?

• The TRIM function converts a string to uppercase, making it feel like a superhero!

• The TRIM function removes leading and trailing whitespace from a string, like a ninja with a sword!

• The TRIM function adds extra spaces to a string, because who doesn't love a little extra room?

• The TRIM function counts the number of characters in a string, like a librarian on a caffeine rush!

How can you convert text to uppercase in Excel?

• Use the UPPER function, e.g., =UPPER(A1). It's like giving your text a caffeine boost!

• Use the LOWER function, e.g., =LOWER(A1). Because who doesn't love a good nap?

• Change the font color to blue. Because blue is the color of sadness, and we don't want sad text!

• Apply bold formatting to the text. Make it shout, 'Look at me!' without actually yelling!

What is the purpose of a pivot chart?

• To format cells in a spreadsheet, because they need a makeover!

• The purpose of a pivot chart is to visually summarize and analyze data from a pivot table, like a data magician!

• To delete existing data, because who needs the past?

• To create a new pivot table, because the old one was just too boring!

Which of the following is NOT a data type in Excel?

• date (because who needs to remember birthdays?)

• text (for all your dramatic Excel novels)

• image (unless you want to see your cat in a spreadsheet)

• number (the only thing that counts!)

What is the first step in creating a pivot table?

• Insert a formula (and hope it doesn't explode)

• Choose a chart type (because pie charts are delicious)

• Filter the data set (like filtering out bad jokes)

• Select the data range (the bigger, the better!)

How do you change the data type of a column in Power Query?

• Double-click the column and type the new data type directly, like a magician pulling a rabbit out of a hat!

• Right-click the column header, select 'Change Type', and choose the desired data type, because who doesn't love a good menu?

• Select the column, then click 'Remove' to delete it, like a bad date you just want to forget!

• Use the 'Transform' menu and choose 'Add Column' to change the type, because more is always merrier!

What is the main function of Power BI?

• To perform statistical analysis and data mining while wearing a party hat.

• To create spreadsheets and manage databases like a spreadsheet ninja.

• To develop software applications and websites, but only if they come with free pizza.

• The main function of Power BI is to provide data visualization and business intelligence capabilities, because who doesn't love pretty graphs?

Which function converts text to lowercase in Excel?

• LOWER - Because shouting is overrated!

• LOWERCASE - For when you want to whisper!

• TEXTCASE - The case of the missing text!

• UPPER - For when you want to yell!