- Tutorials
- Courses
- Tracks
MS Excel Quiz Day 56
Question 1
How can you insert an emoji in Google Sheets on a Windows computer?
Ctrl + Shift + V
Windows key + period (.)
Ctrl + Alt + M
Ctrl + Shift + F
Question 2
What does the Google Sheets function =EMOJI("smiley") do?
Inserts a smiley face emoji
Returns the Unicode value of a smiley
Formats a cell as bold
Splits data into columns
Question 3
What is a benefit of using keyboard shortcuts in Google Sheets?
Increases repetitive mouse clicks
Saves time and effort
Inserts charts automatically
Translates text
Question 4
How can AI improve data entry in spreadsheets?
By creating charts
By using Flash Fill to recognize patterns
By locking header rows
By inserting hyperlinks
Question 5
How do you split combined data (e.g., full names) in Google Sheets?
Use Ctrl + Shift + V
Use the Split Text to Columns feature
Apply conditional formatting
Insert a comment
Question 6
Which keyboard shortcut inserts the current date in Google Sheets?
Ctrl + ; (Cmd + ; on Mac)
Ctrl + Shift + V (Cmd + Shift + V on Mac)
Ctrl + Alt + V (Cmd + Option + V on Mac)
Ctrl + Shift + F (Cmd + Shift + F on Mac)
Question 7
What is a use case for AI in Google Sheets for B2B event data management?
Locking header rows
Sending follow-up emails via Power Automate
Applying border formatting
Inserting emojis
Question 8
How can you insert an emoji in Google Sheets using the menu?
Insert > Chart
Insert > Emoji
Data > Data Validation
Format > Conditional Formatting
Question 9
What does the CHAR function do in Google Sheets?
Translates text to another language
Inserts a character based on its Unicode value
Summarizes data with SUM or AVERAGE
Sends email notifications
Question 10
How can you check for valid email addresses in Google Sheets?
Use the Split Text to Columns feature
Use a built-in validation feature
Apply conditional formatting
Insert a comment
There are 10 questions to complete.